﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           1,
           'String', 
           'System.String'
      );
INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           2,
           'Long', 
           'System.Int64'
      );

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           3,
           'Integer', 
           'System.Int32'
      );

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           4,
           'Double', 
           'System.Double'
      );

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           5,
           'Decimal', 
           'System.Decimal'
      );

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           6,
           'DateTime', 
           'System.DateTime'
      );

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           7,
           'Boolean', 
           'System.Boolean'
      );

INSERT INTO [BPMEngine].[dbo].[DataTypes]
           ([DataTypeId]
		   ,[DataTypeName]
           ,[ClrType])
     VALUES
     (
           8,
           'Address', 
           'YasharEl.Infrastructure.Core.Locations.Address'
      );
GO
